Diagram GEN_Authorisation

Defincja diagramu GEN_Authorisation

Name

GEN_Authorisation

Code

GEN_Authorisation

Comment

 


Lista tabel diagramu

Name

Code

ActionCode

ActionCode

AuthorisationRule

AuthorisationRule

AuthorisationSigns

AuthorisationSigns

FormDefinition

FormDefinition

LAuthorisationPersonnel

LAuthorisationPersonnel

LAuthorisationPersonnelType

LAuthorisationPersonnelType

LAuthorisationRuleUserType

LAuthorisationRuleUserType

LAuthorisationSysFct

LAuthorisationSysFct

LAuthPerfServiceStatus

LAuthPerfServiceStatus

LPerfServiceStatus

LPerfServiceStatus

LServiceAuthorisationRule

LServiceAuthorisationRule

PatientStatus

PatientStatus

Person

Person

Personnel

Personnel

PersonnelType

PersonnelType

Reason

Reason

Service

Service

ServiceAutorisation

ServiceAutorisation

SysFct

SysFct

UserType

UserType


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_908

R_908

AuthorisationRule

LAuthorisationPersonnelType

AuthorisationRuleID

 

 

R_909

R_909

PersonnelType

LAuthorisationPersonnelType

PersonnelTypeID

 

 

R_910

R_910

AuthorisationRule

LAuthorisationPersonnel

AuthorisationRuleID

 

 

R_911

R_911

Personnel

LAuthorisationPersonnel

PersonID

 

 

R_922

R_922

AuthorisationRule

LAuthorisationSysFct

AuthorisationRuleID

 

 

R_923

R_923

LPerfServiceStatus

LAuthPerfServiceStatus

LPerfServiceStatusID

 

 

R_924

R_924

SysFct

LAuthorisationSysFct

SysFctID

 

 

R_925

R_925

SysFct

LAuthPerfServiceStatus

SysFctID

 

 

R_926

R_926

PersonnelType

LAuthPerfServiceStatus

PersonnelTypeID

 

 

R_1666

R_1666

UserType

AuthorisationSigns

UserTypeID

 

 

R_1990

R_1990

AuthorisationRule

LAuthorisationRuleUserType

AuthorisationRuleID

 

 

R_1991

R_1991

UserType

LAuthorisationRuleUserType

UserTypeID

 

 

R_1992

R_1992

AuthorisationRule

LServiceAuthorisationRule

AuthorisationRuleID

 

 

R_1993

R_1993

Service

LServiceAuthorisationRule

ServID

 

 

R_2000

R_2000

UserType

LPerfServiceStatus

UserTypeID

 

 

R_4000

R_4000

AuthorisationRule

LPerfServiceStatus

AuthorisationRuleID

 

 

R_5010

R_5010

ActionCode

LPerfServiceStatus

ActionCodeID

 

 

R_5011

R_5011

PatientStatus

LPerfServiceStatus

PatientStatusID

 

 

R_5030

R_5030

AuthorisationRule

FormDefinition

AuthorisationRuleID

 

 

R_5031

R_5031

Person

AuthorisationSigns

PersonID

 

 

R_5032

R_5032

AuthorisationRule

AuthorisationSigns

AuthorisationRuleID

 

 

R_5033

R_5033

AuthorisationSigns

LPerfServiceStatus

AuthorisationSignID

 

 

R_10389

R_10389

Reason

LPerfServiceStatus

ReasonID